RIGHT

Also applies to:

RIGHTB

RIGHT returns the last character or characters in a text string, based on the number of characters you specify.

RIGHTB returns the last character or characters in a text string, based on the number of bytes you specify. This function is for use with double-byte characters.

Syntax

RIGHT(text,num_chars)

RIGHTB(text,num_bytes)

Text is the text string containing the characters you want to extract.

Num_chars specifies the number of characters you want RIGHT to extract.

Num_bytes specifies the number of characters you want RIGHTB to extract, based on bytes.

Remarks

Num_chars must be greater than or equal to zero.
If num_chars is greater than the length of text, RIGHT returns all of text.
If num_chars is omitted, it is assumed to be 1.

Example (RIGHT)

The example may be easier to understand if you copy it to a blank worksheet.

Show How?

Create a blank workbook or worksheet.
Select the example in the Help topic. Do not select the row or column headers.

Selecting an example from Help
Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.
To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.

1

2
3

A
Data
Sale Price
Stock Number
Formula	Description (Result)
=RIGHT(A2,5)	Last 5 characters of the first string (Price)
=RIGHT(A3)	Last character of the second string (r)

Example (RIGHTB)

=RIGHTB(" Tokyo to Shibuya ",2) equals ""